
/* ===========================================================
 * JFreeChart : a free chart library for the Java(tm) platform
 * ===========================================================
 *
 * (C) Copyright 2000-2004, by Object Refinery Limited and Contributors.
 *
 * Project Info:  http://www.jfree.org/jfreechart/index.html
 *
 * This library is free software; you can redistribute it and/or modify it under the terms
 * of the GNU Lesser General Public License as published by the Free Software Foundation;
 * either version 2.1 of the License, or (at your option) any later version.
 *
 * This library is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY;
 * without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
 * See the GNU Lesser General Public License for more details.
 *
 * You should have received a copy of the GNU Lesser General Public License along with this
 * library; if not, write to the Free Software Foundation, Inc., 59 Temple Place, Suite 330,
 * Boston, MA 02111-1307, USA.
 *
 * [Java is a trademark or registered trademark of Sun Microsystems, Inc. 
 * in the United States and other countries.]
 *
 * ------------------
 * PieChartDemo7.java
 * ------------------
 * (C) Copyright 2004, by Object Refinery Limited and Contributors.
 *
 * Original Author:  David Gilbert (for Object Refinery Limited);
 * Contributor(s):   -;
 *
 * $Id: PieChartDemo7.java,v 1.1 2004/05/26 13:02:03 mungady Exp $
 *
 * Changes
 * -------
 * 25-May-2004 : Version 1 (DG);
 *
 */



import clases.conexion;
import java.awt.Dimension;
import java.awt.GridLayout;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import javax.swing.JOptionPane;
import javax.swing.JPanel;

import org.jfree.chart.ChartFactory;
import org.jfree.chart.ChartPanel;
import org.jfree.chart.JFreeChart;
import org.jfree.chart.plot.PiePlot;
import org.jfree.chart.plot.PiePlot3D;
import org.jfree.data.general.DefaultPieDataset;
import org.jfree.ui.ApplicationFrame;
import org.jfree.ui.RefineryUtilities;

/**
 * A demo showing four pie charts.
 */
public class PieChartDemo7 extends ApplicationFrame {

    /**
     * Creates a new demo instance.
     * 
     * @param title  the frame title.
     */
    
     public void Conectar(){
        try{
            mdbc = new conexion();
            mdbc.init();
            Connection conn= mdbc.getMyConnection();
            stmt = conn.createStatement();
        }catch(Exception ex)
        {
            JOptionPane.showMessageDialog(null, "Problemas al concetarse a la Base de Datos","Error",JOptionPane.ERROR_MESSAGE);
        }
    }
    public PieChartDemo7(String title) throws SQLException {

        super(title);
        JPanel panel = new JPanel(new GridLayout(2, 2));
       String comando= "select b.idestadoanimal , e.descripcion , count(*) as total, "
                + " round(((count(*)  * 100)/ (select count(*) from bovino)),2) as porcentaje"
                + " from bovino b , estadoanimal e where b.idestadoanimal<=4 "
                + "and b.idestadoanimal= e.idestadoanimal and b.sexo='H' group by b.idestadoanimal";
     
     
     
    DefaultPieDataset data = new DefaultPieDataset();
        
        try{
            Conectar();
            ResultSet rs = stmt.executeQuery(comando);
             rs.beforeFirst();
             
             while(rs.next()){
                 
                         String estado= rs.getString("descripcion");
                         String porcentaje = rs.getString("porcentaje");
                         data.setValue(estado+":"+porcentaje,Float.parseFloat(porcentaje));
             }
        
        
        JFreeChart chart3 = ChartFactory.createPieChart3D("Chart 3", data, false, false, false);
        PiePlot3D plot3 = (PiePlot3D) chart3.getPlot();
        plot3.setForegroundAlpha(0.6f);
        plot3.setCircular(true);
        panel.add(new ChartPanel(chart3));
        

        panel.setPreferredSize(new Dimension(800, 600));
        setContentPane(panel);

    }catch(Exception ex){
            JOptionPane.showMessageDialog(null,ex.getMessage(),"ERROR",JOptionPane.ERROR_MESSAGE);
        }
     
     
    }    

    /**
     * The starting point for the demo.
     * 
     * @param args  ignored.
     */
    public static void main(String[] args) throws SQLException {
        PieChartDemo7 demo = new PieChartDemo7("Pie Chart Demo 7");
        demo.pack();
        RefineryUtilities.centerFrameOnScreen(demo);
        demo.setVisible(true);
    }
private conexion mdbc;
    private Statement stmt;
}